package com.ztesoft.web.common.db.arg;

import java.util.*;
import java.math.*;
import org.apache.commons.lang.*;

public class DbBaseInfoArg {
    private String pk_name = "db_base_id";

    private String orderByClause;

    private String groupByClause;

    private String columns;

    private String countsql1;

    private String countsql2;

    private boolean distinct;

    private int rowStart = 0;

    private int rowEnd = 10;

    private List<DbBaseInfoCriteria> oredCriteria;

    public DbBaseInfoArg() {
        oredCriteria = new ArrayList<DbBaseInfoCriteria>();
    }

    public void setPk_name(String pk_name) {
        this.pk_name = StringEscapeUtils.escapeSql(pk_name);
    }

    public String getPk_name() {
        return pk_name;
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = StringEscapeUtils.escapeSql(orderByClause);
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setGroupByClause(String groupByClause) {
        this.groupByClause = StringEscapeUtils.escapeSql(groupByClause);
    }

    public String geGroupByClause() {
        return groupByClause;
    }

    public void setColumns(String columns) {
        this.columns = StringEscapeUtils.escapeSql(columns);
    }

    public String geColumns() {
        return columns;
    }

    public void setCountsql1(String countsql1) {
        this.countsql1 = StringEscapeUtils.escapeSql(countsql1);
    }

    public String geCountsql1() {
        return countsql1;
    }

    public void setCountsql2(String countsql2) {
        this.countsql2 = StringEscapeUtils.escapeSql(countsql2);
    }

    public String geCountsql2() {
        return countsql2;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public void setRowStart(int rowStart) {
        this.rowStart = rowStart;
    }

    public void setRowEnd(int rowEnd) {
        this.rowEnd = rowEnd;
    }

    public int getRowStart() {
        return rowStart;
    }

    public int getRowEnd() {
        return rowEnd;
    }

    public List<DbBaseInfoCriteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(DbBaseInfoCriteria criteria) {
        oredCriteria.add(criteria);
    }

    public DbBaseInfoCriteria or() {
    	DbBaseInfoCriteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public DbBaseInfoCriteria createCriteria() {
    	DbBaseInfoCriteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected DbBaseInfoCriteria createCriteriaInternal() {
    	DbBaseInfoCriteria criteria = new DbBaseInfoCriteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        groupByClause = null;
        columns = null;
        countsql1 = null;
        countsql2 = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<DbBaseInfoCriterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<DbBaseInfoCriterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<DbBaseInfoCriterion> getAllCriteria() {
            return criteria;
        }

        public List<DbBaseInfoCriterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new DbBaseInfoCriterion(condition));
        }

        protected void addCriterion(String condition, Object value,
                String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property
                        + " cannot be null");
            }
            criteria.add(new DbBaseInfoCriterion(condition, value));
        }

        protected void addCriterion(String condition, Object value,
                String property, int likeType) {
            if (value == null) {
                throw new RuntimeException("Value for " + property
                        + " cannot be null");
            }
            criteria.add(new DbBaseInfoCriterion(condition, value, likeType));
        }

        protected void addCriterion(String condition, Object value1,
                Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property
                        + " cannot be null");
            }
            criteria.add(new DbBaseInfoCriterion(condition, value1, value2));
        }

        public DbBaseInfoCriteria andCriterionEqualTo(String criterion) {
            if (StringUtils.isBlank(criterion)) {
                criterion = "1=1";
            }
            addCriterion(criterion);
            return (DbBaseInfoCriteria) this;
        }
        public DbBaseInfoCriteria andDbBaseIdIsNull() {
            addCriterion("db_base_id is null");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbBaseIdIsNotNull() {
            addCriterion("db_base_id is not null");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbBaseIdEqualTo(Integer value) {
            addCriterion("db_base_id =", value, "db_base_id");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbBaseIdNotEqualTo(Integer value) {
            addCriterion("db_base_id <>", value, "db_base_id");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbBaseIdGreaterThan(Integer value) {
            addCriterion("db_base_id >", value, "db_base_id");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbBaseIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("db_base_id >=", value, "db_base_id");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbBaseIdLessThan(Integer value) {
            addCriterion("db_base_id <", value, "db_base_id");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbBaseIdLessThanOrEqualTo(Integer value) {
            addCriterion("db_base_id <=", value, "db_base_id");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbBaseIdLike(Integer value) {
            addCriterion("db_base_id like ", value, "db_base_id", 1);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbBaseIdNotLike(Integer value) {
            addCriterion("db_base_id  not like ", value, "db_base_id", 1);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbBaseIdLeftLike(Integer value) {
            addCriterion("db_base_id like ", value, "db_base_id", 0);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbBaseIdNotLeftLike(Integer value) {
            addCriterion("db_base_id  not like ", value, "db_base_id", 0);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbBaseIdRightLike(Integer value) {
            addCriterion("db_base_id like ", value, "db_base_id", 2);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbBaseIdNotRightLike(Integer value) {
            addCriterion("db_base_id  not like ", value, "db_base_id", 2);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbBaseIdIn(List<Integer> values) {
            addCriterion("db_base_id  in ", values, "db_base_id");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbBaseIdNotIn(List<Integer> values) {
            addCriterion("db_base_id not in ", values, "db_base_id");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbBaseIdBetween(Integer value1, Integer value2) {
            addCriterion("db_base_id between ", value1, value2, "db_base_id");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbBaseIdNotBetween(Integer value1, Integer value2) {
            addCriterion("db_base_id not between ", value1, value2, "db_base_id");
            return (DbBaseInfoCriteria) this;
        }
        public DbBaseInfoCriteria andDbHostNameIsNull() {
            addCriterion("db_host_name is null");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostNameIsNotNull() {
            addCriterion("db_host_name is not null");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostNameEqualTo(String value) {
            addCriterion("db_host_name =", value, "db_host_name");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostNameNotEqualTo(String value) {
            addCriterion("db_host_name <>", value, "db_host_name");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostNameGreaterThan(String value) {
            addCriterion("db_host_name >", value, "db_host_name");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostNameGreaterThanOrEqualTo(String value) {
            addCriterion("db_host_name >=", value, "db_host_name");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostNameLessThan(String value) {
            addCriterion("db_host_name <", value, "db_host_name");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostNameLessThanOrEqualTo(String value) {
            addCriterion("db_host_name <=", value, "db_host_name");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostNameLike(String value) {
            addCriterion("db_host_name like ", value, "db_host_name", 1);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostNameNotLike(String value) {
            addCriterion("db_host_name  not like ", value, "db_host_name", 1);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostNameLeftLike(String value) {
            addCriterion("db_host_name like ", value, "db_host_name", 0);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostNameNotLeftLike(String value) {
            addCriterion("db_host_name  not like ", value, "db_host_name", 0);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostNameRightLike(String value) {
            addCriterion("db_host_name like ", value, "db_host_name", 2);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostNameNotRightLike(String value) {
            addCriterion("db_host_name  not like ", value, "db_host_name", 2);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostNameIn(List<String> values) {
            addCriterion("db_host_name  in ", values, "db_host_name");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostNameNotIn(List<String> values) {
            addCriterion("db_host_name not in ", values, "db_host_name");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostNameBetween(String value1, String value2) {
            addCriterion("db_host_name between ", value1, value2, "db_host_name");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostNameNotBetween(String value1, String value2) {
            addCriterion("db_host_name not between ", value1, value2, "db_host_name");
            return (DbBaseInfoCriteria) this;
        }
        public DbBaseInfoCriteria andDbHostIpIsNull() {
            addCriterion("db_host_ip is null");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostIpIsNotNull() {
            addCriterion("db_host_ip is not null");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostIpEqualTo(String value) {
            addCriterion("db_host_ip =", value, "db_host_ip");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostIpNotEqualTo(String value) {
            addCriterion("db_host_ip <>", value, "db_host_ip");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostIpGreaterThan(String value) {
            addCriterion("db_host_ip >", value, "db_host_ip");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostIpGreaterThanOrEqualTo(String value) {
            addCriterion("db_host_ip >=", value, "db_host_ip");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostIpLessThan(String value) {
            addCriterion("db_host_ip <", value, "db_host_ip");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostIpLessThanOrEqualTo(String value) {
            addCriterion("db_host_ip <=", value, "db_host_ip");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostIpLike(String value) {
            addCriterion("db_host_ip like ", value, "db_host_ip", 1);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostIpNotLike(String value) {
            addCriterion("db_host_ip  not like ", value, "db_host_ip", 1);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostIpLeftLike(String value) {
            addCriterion("db_host_ip like ", value, "db_host_ip", 0);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostIpNotLeftLike(String value) {
            addCriterion("db_host_ip  not like ", value, "db_host_ip", 0);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostIpRightLike(String value) {
            addCriterion("db_host_ip like ", value, "db_host_ip", 2);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostIpNotRightLike(String value) {
            addCriterion("db_host_ip  not like ", value, "db_host_ip", 2);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostIpIn(List<String> values) {
            addCriterion("db_host_ip  in ", values, "db_host_ip");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostIpNotIn(List<String> values) {
            addCriterion("db_host_ip not in ", values, "db_host_ip");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostIpBetween(String value1, String value2) {
            addCriterion("db_host_ip between ", value1, value2, "db_host_ip");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostIpNotBetween(String value1, String value2) {
            addCriterion("db_host_ip not between ", value1, value2, "db_host_ip");
            return (DbBaseInfoCriteria) this;
        }
        public DbBaseInfoCriteria andDbHostPortIsNull() {
            addCriterion("db_host_port is null");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostPortIsNotNull() {
            addCriterion("db_host_port is not null");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostPortEqualTo(String value) {
            addCriterion("db_host_port =", value, "db_host_port");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostPortNotEqualTo(String value) {
            addCriterion("db_host_port <>", value, "db_host_port");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostPortGreaterThan(String value) {
            addCriterion("db_host_port >", value, "db_host_port");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostPortGreaterThanOrEqualTo(String value) {
            addCriterion("db_host_port >=", value, "db_host_port");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostPortLessThan(String value) {
            addCriterion("db_host_port <", value, "db_host_port");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostPortLessThanOrEqualTo(String value) {
            addCriterion("db_host_port <=", value, "db_host_port");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostPortLike(String value) {
            addCriterion("db_host_port like ", value, "db_host_port", 1);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostPortNotLike(String value) {
            addCriterion("db_host_port  not like ", value, "db_host_port", 1);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostPortLeftLike(String value) {
            addCriterion("db_host_port like ", value, "db_host_port", 0);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostPortNotLeftLike(String value) {
            addCriterion("db_host_port  not like ", value, "db_host_port", 0);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostPortRightLike(String value) {
            addCriterion("db_host_port like ", value, "db_host_port", 2);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostPortNotRightLike(String value) {
            addCriterion("db_host_port  not like ", value, "db_host_port", 2);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostPortIn(List<String> values) {
            addCriterion("db_host_port  in ", values, "db_host_port");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostPortNotIn(List<String> values) {
            addCriterion("db_host_port not in ", values, "db_host_port");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostPortBetween(String value1, String value2) {
            addCriterion("db_host_port between ", value1, value2, "db_host_port");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbHostPortNotBetween(String value1, String value2) {
            addCriterion("db_host_port not between ", value1, value2, "db_host_port");
            return (DbBaseInfoCriteria) this;
        }
        public DbBaseInfoCriteria andDbNameIsNull() {
            addCriterion("db_name is null");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbNameIsNotNull() {
            addCriterion("db_name is not null");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbNameEqualTo(String value) {
            addCriterion("db_name =", value, "db_name");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbNameNotEqualTo(String value) {
            addCriterion("db_name <>", value, "db_name");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbNameGreaterThan(String value) {
            addCriterion("db_name >", value, "db_name");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbNameGreaterThanOrEqualTo(String value) {
            addCriterion("db_name >=", value, "db_name");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbNameLessThan(String value) {
            addCriterion("db_name <", value, "db_name");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbNameLessThanOrEqualTo(String value) {
            addCriterion("db_name <=", value, "db_name");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbNameLike(String value) {
            addCriterion("db_name like ", value, "db_name", 1);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbNameNotLike(String value) {
            addCriterion("db_name  not like ", value, "db_name", 1);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbNameLeftLike(String value) {
            addCriterion("db_name like ", value, "db_name", 0);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbNameNotLeftLike(String value) {
            addCriterion("db_name  not like ", value, "db_name", 0);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbNameRightLike(String value) {
            addCriterion("db_name like ", value, "db_name", 2);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbNameNotRightLike(String value) {
            addCriterion("db_name  not like ", value, "db_name", 2);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbNameIn(List<String> values) {
            addCriterion("db_name  in ", values, "db_name");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbNameNotIn(List<String> values) {
            addCriterion("db_name not in ", values, "db_name");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbNameBetween(String value1, String value2) {
            addCriterion("db_name between ", value1, value2, "db_name");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbNameNotBetween(String value1, String value2) {
            addCriterion("db_name not between ", value1, value2, "db_name");
            return (DbBaseInfoCriteria) this;
        }
        public DbBaseInfoCriteria andDbDescIsNull() {
            addCriterion("db_desc is null");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbDescIsNotNull() {
            addCriterion("db_desc is not null");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbDescEqualTo(String value) {
            addCriterion("db_desc =", value, "db_desc");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbDescNotEqualTo(String value) {
            addCriterion("db_desc <>", value, "db_desc");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbDescGreaterThan(String value) {
            addCriterion("db_desc >", value, "db_desc");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbDescGreaterThanOrEqualTo(String value) {
            addCriterion("db_desc >=", value, "db_desc");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbDescLessThan(String value) {
            addCriterion("db_desc <", value, "db_desc");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbDescLessThanOrEqualTo(String value) {
            addCriterion("db_desc <=", value, "db_desc");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbDescLike(String value) {
            addCriterion("db_desc like ", value, "db_desc", 1);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbDescNotLike(String value) {
            addCriterion("db_desc  not like ", value, "db_desc", 1);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbDescLeftLike(String value) {
            addCriterion("db_desc like ", value, "db_desc", 0);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbDescNotLeftLike(String value) {
            addCriterion("db_desc  not like ", value, "db_desc", 0);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbDescRightLike(String value) {
            addCriterion("db_desc like ", value, "db_desc", 2);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbDescNotRightLike(String value) {
            addCriterion("db_desc  not like ", value, "db_desc", 2);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbDescIn(List<String> values) {
            addCriterion("db_desc  in ", values, "db_desc");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbDescNotIn(List<String> values) {
            addCriterion("db_desc not in ", values, "db_desc");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbDescBetween(String value1, String value2) {
            addCriterion("db_desc between ", value1, value2, "db_desc");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbDescNotBetween(String value1, String value2) {
            addCriterion("db_desc not between ", value1, value2, "db_desc");
            return (DbBaseInfoCriteria) this;
        }
        public DbBaseInfoCriteria andStateIsNull() {
            addCriterion("state is null");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andStateIsNotNull() {
            addCriterion("state is not null");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andStateEqualTo(String value) {
            addCriterion("state =", value, "state");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andStateNotEqualTo(String value) {
            addCriterion("state <>", value, "state");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andStateGreaterThan(String value) {
            addCriterion("state >", value, "state");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andStateGreaterThanOrEqualTo(String value) {
            addCriterion("state >=", value, "state");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andStateLessThan(String value) {
            addCriterion("state <", value, "state");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andStateLessThanOrEqualTo(String value) {
            addCriterion("state <=", value, "state");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andStateLike(String value) {
            addCriterion("state like ", value, "state", 1);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andStateNotLike(String value) {
            addCriterion("state  not like ", value, "state", 1);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andStateLeftLike(String value) {
            addCriterion("state like ", value, "state", 0);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andStateNotLeftLike(String value) {
            addCriterion("state  not like ", value, "state", 0);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andStateRightLike(String value) {
            addCriterion("state like ", value, "state", 2);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andStateNotRightLike(String value) {
            addCriterion("state  not like ", value, "state", 2);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andStateIn(List<String> values) {
            addCriterion("state  in ", values, "state");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andStateNotIn(List<String> values) {
            addCriterion("state not in ", values, "state");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andStateBetween(String value1, String value2) {
            addCriterion("state between ", value1, value2, "state");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andStateNotBetween(String value1, String value2) {
            addCriterion("state not between ", value1, value2, "state");
            return (DbBaseInfoCriteria) this;
        }
        public DbBaseInfoCriteria andSystemIdIsNull() {
            addCriterion("system_id is null");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andSystemIdIsNotNull() {
            addCriterion("system_id is not null");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andSystemIdEqualTo(Integer value) {
            addCriterion("system_id =", value, "system_id");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andSystemIdNotEqualTo(Integer value) {
            addCriterion("system_id <>", value, "system_id");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andSystemIdGreaterThan(Integer value) {
            addCriterion("system_id >", value, "system_id");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andSystemIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("system_id >=", value, "system_id");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andSystemIdLessThan(Integer value) {
            addCriterion("system_id <", value, "system_id");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andSystemIdLessThanOrEqualTo(Integer value) {
            addCriterion("system_id <=", value, "system_id");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andSystemIdLike(Integer value) {
            addCriterion("system_id like ", value, "system_id", 1);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andSystemIdNotLike(Integer value) {
            addCriterion("system_id  not like ", value, "system_id", 1);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andSystemIdLeftLike(Integer value) {
            addCriterion("system_id like ", value, "system_id", 0);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andSystemIdNotLeftLike(Integer value) {
            addCriterion("system_id  not like ", value, "system_id", 0);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andSystemIdRightLike(Integer value) {
            addCriterion("system_id like ", value, "system_id", 2);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andSystemIdNotRightLike(Integer value) {
            addCriterion("system_id  not like ", value, "system_id", 2);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andSystemIdIn(List<Integer> values) {
            addCriterion("system_id  in ", values, "system_id");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andSystemIdNotIn(List<Integer> values) {
            addCriterion("system_id not in ", values, "system_id");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andSystemIdBetween(Integer value1, Integer value2) {
            addCriterion("system_id between ", value1, value2, "system_id");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andSystemIdNotBetween(Integer value1, Integer value2) {
            addCriterion("system_id not between ", value1, value2, "system_id");
            return (DbBaseInfoCriteria) this;
        }
        public DbBaseInfoCriteria andDbCategoryIsNull() {
            addCriterion("db_category is null");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbCategoryIsNotNull() {
            addCriterion("db_category is not null");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbCategoryEqualTo(String value) {
            addCriterion("db_category =", value, "db_category");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbCategoryNotEqualTo(String value) {
            addCriterion("db_category <>", value, "db_category");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbCategoryGreaterThan(String value) {
            addCriterion("db_category >", value, "db_category");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbCategoryGreaterThanOrEqualTo(String value) {
            addCriterion("db_category >=", value, "db_category");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbCategoryLessThan(String value) {
            addCriterion("db_category <", value, "db_category");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbCategoryLessThanOrEqualTo(String value) {
            addCriterion("db_category <=", value, "db_category");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbCategoryLike(String value) {
            addCriterion("db_category like ", value, "db_category", 1);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbCategoryNotLike(String value) {
            addCriterion("db_category  not like ", value, "db_category", 1);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbCategoryLeftLike(String value) {
            addCriterion("db_category like ", value, "db_category", 0);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbCategoryNotLeftLike(String value) {
            addCriterion("db_category  not like ", value, "db_category", 0);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbCategoryRightLike(String value) {
            addCriterion("db_category like ", value, "db_category", 2);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbCategoryNotRightLike(String value) {
            addCriterion("db_category  not like ", value, "db_category", 2);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbCategoryIn(List<String> values) {
            addCriterion("db_category  in ", values, "db_category");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbCategoryNotIn(List<String> values) {
            addCriterion("db_category not in ", values, "db_category");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbCategoryBetween(String value1, String value2) {
            addCriterion("db_category between ", value1, value2, "db_category");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andDbCategoryNotBetween(String value1, String value2) {
            addCriterion("db_category not between ", value1, value2, "db_category");
            return (DbBaseInfoCriteria) this;
        }
        public DbBaseInfoCriteria andCreateDateIsNull() {
            addCriterion("create_date is null");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andCreateDateIsNotNull() {
            addCriterion("create_date is not null");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andCreateDateEqualTo(String value) {
            addCriterion("create_date =", value, "create_date");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andCreateDateNotEqualTo(String value) {
            addCriterion("create_date <>", value, "create_date");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andCreateDateGreaterThan(String value) {
            addCriterion("create_date >", value, "create_date");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andCreateDateGreaterThanOrEqualTo(String value) {
            addCriterion("create_date >=", value, "create_date");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andCreateDateLessThan(String value) {
            addCriterion("create_date <", value, "create_date");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andCreateDateLessThanOrEqualTo(String value) {
            addCriterion("create_date <=", value, "create_date");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andCreateDateLike(String value) {
            addCriterion("create_date like ", value, "create_date", 1);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andCreateDateNotLike(String value) {
            addCriterion("create_date  not like ", value, "create_date", 1);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andCreateDateLeftLike(String value) {
            addCriterion("create_date like ", value, "create_date", 0);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andCreateDateNotLeftLike(String value) {
            addCriterion("create_date  not like ", value, "create_date", 0);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andCreateDateRightLike(String value) {
            addCriterion("create_date like ", value, "create_date", 2);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andCreateDateNotRightLike(String value) {
            addCriterion("create_date  not like ", value, "create_date", 2);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andCreateDateIn(List<String> values) {
            addCriterion("create_date  in ", values, "create_date");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andCreateDateNotIn(List<String> values) {
            addCriterion("create_date not in ", values, "create_date");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andCreateDateBetween(String value1, String value2) {
            addCriterion("create_date between ", value1, value2, "create_date");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andCreateDateNotBetween(String value1, String value2) {
            addCriterion("create_date not between ", value1, value2, "create_date");
            return (DbBaseInfoCriteria) this;
        }
        public DbBaseInfoCriteria andStateDateIsNull() {
            addCriterion("state_date is null");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andStateDateIsNotNull() {
            addCriterion("state_date is not null");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andStateDateEqualTo(String value) {
            addCriterion("state_date =", value, "state_date");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andStateDateNotEqualTo(String value) {
            addCriterion("state_date <>", value, "state_date");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andStateDateGreaterThan(String value) {
            addCriterion("state_date >", value, "state_date");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andStateDateGreaterThanOrEqualTo(String value) {
            addCriterion("state_date >=", value, "state_date");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andStateDateLessThan(String value) {
            addCriterion("state_date <", value, "state_date");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andStateDateLessThanOrEqualTo(String value) {
            addCriterion("state_date <=", value, "state_date");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andStateDateLike(String value) {
            addCriterion("state_date like ", value, "state_date", 1);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andStateDateNotLike(String value) {
            addCriterion("state_date  not like ", value, "state_date", 1);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andStateDateLeftLike(String value) {
            addCriterion("state_date like ", value, "state_date", 0);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andStateDateNotLeftLike(String value) {
            addCriterion("state_date  not like ", value, "state_date", 0);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andStateDateRightLike(String value) {
            addCriterion("state_date like ", value, "state_date", 2);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andStateDateNotRightLike(String value) {
            addCriterion("state_date  not like ", value, "state_date", 2);
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andStateDateIn(List<String> values) {
            addCriterion("state_date  in ", values, "state_date");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andStateDateNotIn(List<String> values) {
            addCriterion("state_date not in ", values, "state_date");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andStateDateBetween(String value1, String value2) {
            addCriterion("state_date between ", value1, value2, "state_date");
            return (DbBaseInfoCriteria) this;
        }

        public DbBaseInfoCriteria andStateDateNotBetween(String value1, String value2) {
            addCriterion("state_date not between ", value1, value2, "state_date");
            return (DbBaseInfoCriteria) this;
        }

    }

    public static class DbBaseInfoCriteria extends GeneratedCriteria {

        protected DbBaseInfoCriteria() {
            super();
        }
    }

    public static class DbBaseInfoCriterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected DbBaseInfoCriterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }
        protected DbBaseInfoCriterion(String condition, Object value, int likeType) {
            this.condition = condition;
            if (likeType == 0) {
                this.value = "%" + value;
            }
            else if (likeType == 1) {
                this.value = "%" + value + "%";
            }
            else {
                this.value = value + "%";
            }
            this.typeHandler = null;
            this.singleValue = true;

        }

        protected DbBaseInfoCriterion(String condition, Object value,
                String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            }
            else {
                this.singleValue = true;
            }
        }

        protected DbBaseInfoCriterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected DbBaseInfoCriterion(String condition, Object value,
                Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected DbBaseInfoCriterion(String condition, Object value,
                Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}